1.
SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')

2.
select COUNT (*) From  Oit_File where LEN(File_Description)>250
select COUNT (*) From  Oit_Folder where LEN(Folder_Name)>200

3.
select distinct rTrim(LTrim(reverse(left(reverse(File_Name),charindex('.',reverse(File_Name)))))) Extension from OIT_File
    where rTrim(LTrim(reverse(left(reverse(File_Name),charindex('.',reverse(File_Name)))))) != '.html'

4.
select count (*) from OIT_Folder
select count (*) from OIT_File

5.
select File_Name, FolderId, COUNT(FileId) FileId
 from (select a.REC_id FileId, Folder_Rec_ID FolderId,(SubString(File_Description, 1,250)+ ''+ RIGHT(File_Name, Len(File_Name) - Charindex('.', File_Name) +1)) File_Name
				from oit_file  a
					join oit_folder d on a.Folder_Rec_Id = d.Rec_ID
					join TDmsDoctype b on a.Doctype_id = b.Doctype_id					
				  where ((a.IsRecycle = 0) and (a.Mark_For_Delete = 0))
 ) a
Group by  File_Name, FolderId
Having COUNT(FileId)  >1

6.
Select * from mstCompany = gives you the company ID:
update MstCompany set Abbreviation = <'Abbreviation limited to 5 characters'> ‘where id = <id of the company>




7. 5.1 Dupe Checks:
select * from oit_folder where mark_for_delete = 0 and folder_parent in (select child_rec_id from oit_folder_matrix where parent_rec_id = 3)
go
select * from oit_file where mark_for_delete = 0 and folder_rec_id in (select child_rec_id from oit_folder_matrix where parent_rec_id = 3)
go



select * from (
select folder_parent, folder_name, count(*) kount
from oit_folder
where folder_type in ('site','cabinet','folder')
and mark_for_delete = 0
group by folder_parent, folder_name) t1
where t1.kount > 1



//--To find duplicate file_description where file is not in recycle bin//
select   Folder_rec_id, file_description,
         count(*) from     oit_file
Where folder_rec_id <> 3
group by Folder_rec_id, file_description
having   count(*) > 1


To Fix:
SELECT * FROM OIT_Folder WHERE (Folder_Name LIKE '%David Lloyd%') and Folder_Parent = 12365

update oit_folder SET folder_name = 'David  Lloyd' where rec_id= 48929